there are cases when you are forced to create temporary table in dynamic query. below is sample of creating temporary then select it in dynamic query. declare @tableName varchar(30) set @tableName = ‘TableB’ declare @query nvarchar(4000) set @query = ‘CREATE TABLE #’+@tableName+’ ( id int, data varchar(30) ) insert into #’+@tableName+’ values(1, ”Me”) SELECT * … Continue reading Create temporary table in dynamic query